package com.vpx.server.bean.info.system;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import javax.validation.constraints.NotBlank;
import java.util.List;

@Data
public class SqlParam {
    /** 主键 */
    @ApiModelProperty(value = "主键" , required = true)
    private String id;
    @ApiModelProperty(value = "报表类型1 查询,2 更新", required = true)
    private String type;

    @ApiModelProperty(value = "唯一编码", required = true)
    private String keyCode;

    @ApiModelProperty(value = "报表名称", required = true)
    private String name;

    @ApiModelProperty(value = "查询条件(type为查询才有此字段)")
    private String queryCondition;

    @ApiModelProperty(value = "列表字段配置")
    private String columns;

    @ApiModelProperty(value = "是否定时1定时")
    private String isSchedule;

    @ApiModelProperty(value = "定时器表达式(type为定时任务才有当前信息)")
    private String schedule;

    @ApiModelProperty(value = "自定义分页统计(type为查询才有此信息)")
    private String queryPageSqlText;

    @ApiModelProperty(value = "sql语句")
    private String sqlText;

    @ApiModelProperty(value = "状态，0-停用, 1-正常", required = true)
    private String status;

    @ApiModelProperty(value = "Id列表")
    private List<String> idList;
}
